SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[spSaveEmployee]
@Id int,
@Name VARCHAR(50),
@Gender VARCHAR(10),
@City NVARCHAR(50),
@DateOfBirth DATETIME
AS
BEGIN
UPDATE dbo.tblEmployee SET Name = @Name, Gender = @Gender , City = @City, DateOfBirth = @DateOfBirth
WHERE EmployeeId = @Id
end 

GO
